Our top client in the transportation industry is searching for a Data Modeling Engineer to join their team! Candidates must have 3+ years of experience building data models with Erwin or PowerDesigner, a strong understanding of DML and DDL, and SQL. Azure Databricks experience is a strong preference. If you are building data models (not just consuming data and writing scripts) and have a strong understanding of the physical and logical side of data, this could be the position for you!
*Please make sure you include details about your experience with Erwin or PowerDesigner on your resume for consideration*
100% remote
1+ year contract to hire position with benefits available on contract
Only able to hire from the following states at this time: MO, IL, VA, CO, KS, TX, NC, GA, TN, FL, MI, OK, IN, SC
**Cannot work C2C**
Required
- Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future
- Strong enterprise data modeling expertise
- Must have 3+ years of experience using data modeling tools and methodologies
- Must have 3+ years of experience writing and tuning complex SQLs, and the ability to analyze and make recommendations on results.
- Expertise building conceptual data models through to physical data models and DDL/DML generation
- Experience using either PowerDesigner or Erwin modeling software
- Knowledge of building data assets that are strategic, trusted, and agile with governance for data accountability and responsibility
- Working knowledge of modeling data access layers in an enterprise lakehouse environment
- Well-versed in different data modeling methodologies (3NF, Dimensional, Data Vault)
- Experience with cloud data lake solutions
- Expertise with cloud data, enterprise data lake, and business intelligence development technologies.
Preferred
• Bachelor’s degree in computer science, Computer Information Systems, Management Information Systems, or related field preferred
• Experience with Cloud Lakehouse solutions
• Experience with the following technologies:
- Databricks
- Azure SQL
- Teradata
- PowerBI
- SSRS
